package htlgkr.nodlehs;

public class DBTeacherTbl implements DBTeacherColumns {
	public static final String TABLE_NAME = "teachers";
	public static final String SQL_DROP = "DROP TABLE IF EXISTS teachers";
	public static final String SQL_DEL = "DELETE teachers";
	public static final String[] ALL_COLUMNS = new String[] { tea_ID + " AS _id", tea_first_name, tea_last_name};
	public static final String SQL_CREATE = "CREATE TABLE teachers ( " +
			"tea_ID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, " +
			"tea_first_name VARCHAR2 NOT NULL, " +
			"tea_last_name VARCHAR2 NOT NULL)";
	public static final String SQL_INSERT = "INSERT INTO teachers ( tea_first_name, tea_last_name) VALUES(?,?)";
}
